| Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
| LocationID (PK) | A unique system assigned identifier for the Location. | ID_LCN | Identity | integer | |
| LocationHierarchyGroupID (FK) | Token ID for a LocationHierarchyGroup. | ID_LCN_HRC_GP | Identity | integer | LocationHierarchyGroup(CO_LCN_HRC_GP) |
| SizeUnitOfMeasureCode (FK) | The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. | LU_UOM_SZ | Code | varchar(20) | UnitOfMeasure(CO_UOM) |
| LocationLevelID (FK) | A unique identifier for the Locationlevel, within the location hierarchy that this Location resides at. Eg: Site, RetailStore, Department, DistributionCenter, WareHouse, Floor, Aisle, Rack, Bin, etc... | ID_LV_LCN | Identity | integer | LocationLevel(LO_LV_LCN) |
| ParentLocationID (FK) | A unique system assigned identifier for the Location's parent Location. | ID_LCN_PRNT | Identity | integer | Location(LO_LCN) |
| FunctionCode | A code that describes what business activities and functions are performed in a specific location. Activities may include: ADMIN - Administration functions (no stock or customer services are handled here) DISPLY - Merchandise display (stock is presented to the customer for sale) CUSTSVC - Customer service - Customer merchandise may be picked up, returned, etc. RETADJ - Returns and adjustments - where a customer may return merchandise for a credit or refund. Where customers may request price adjustments (e.g. when they bought a sale item just before it went on special) STOCKPT - Stock Point - Out of customer sight location where merchandise is stored, counted and tracked at a physical and financial level. This could be the "back room" (like you see in shoe stores) or it could be a receiving dock, etc. RECV - Receiving or merchandise intake location where merchandise is physically unloaded and accepted by the retail store into its inventory (or at least acknowledged). And lots more depending on the retailer. These codes should indicate which locations involve merchandise sales and tracking. Based on the examples above DISPLY, STOCKPT, CUSTSVC, RECV and RETADJ all represent types of locations that involve the storage, sale or return of merchandise. There are many additional functions and codes that might be assigned depending on the retailer. As Internet sales open up, the concept of location changes. Instead of physical locations, merchandise tracking may be by URL and HTML name. The goal is still to understand WHERE merchandise is moving and where the ownership gets transferred from one party to another. | CD_FNC | Code4 | char(4) | |
| SizeQuantity | The area of the Location expressed as a quantity in an appropriate UnitOfMeasure | QU_SZ_LCN | Quantity | DECIMAL(9,3) | |
| LocationName | The common name for the Location. | NM_LCN | Name | varchar(40) | |
| SiteID (FK) | Token ID for a Site | ID_STE | Identity | integer | Site(LO_STE) |
| LocationTypeCode (FK) | Designates a category of Location. Examples include: FIXTURE FLOOR SECTION STOREWINDOW ENDCAP Other values as determined by the retailer. | CD_LCN_TYP | Code | varchar(20) | LocationType(LU_LCN_TYP) |